AnalysisFarrie
Haley Farrie
2023-11-13
# Prompts a browser pop-up
gs4_auth()Reading data with the googlesheets4 package
read in gross receipts data
Delete extra variables
change column names to variables
tibble [45 × 26] (S3: tbl_df/tbl/data.frame)
$ timestamp : POSIXct[1:45], format: "2023-11-09 12:49:19" "2023-11-09 12:49:48" ...
$ di_org : chr [1:45] "Stillmeadow Community Projects, Inc." "Itineris Foundation Inc." "Friends of Fort McHenry" "The Baltimore Station" ...
$ di_orgyearsworked: chr [1:45] "More than 5 years" "0-2 years" "0-2 years" "0-2 years" ...
$ di_mled : chr [1:45] "Our top executive position is held by a minority." "Our top executive position is held by a minority., More than 50% of program recipients are minorities." "None of the above" "Our top executive position is held by a minority., More than 50% of our board is made up of minorities., More t"| __truncated__ ...
$ att_purtool : chr [1:45] "Strongly agree" "Strongly agree" "Strongly agree" "Strongly agree" ...
$ att_strtool : chr [1:45] "Strongly agree" "N/A" "Agree" "Agree" ...
$ att_redtime : chr [1:45] "Strongly agree" "N/A" "Neutral" "Neutral" ...
$ att_evquality : chr [1:45] "Strongly agree" "Strongly agree" "Strongly agree" "Strongly agree" ...
$ att_posimpact : chr [1:45] "Strongly agree" "Strongly agree" "Strongly agree" "Strongly agree" ...
$ att_mostimpact : chr [1:45] "Availability of Inexpensive Rental Equipment" "You get me what I need on time and cheaply!" "Renting equipment from the TB has enabled us hold events that we wouldn't have been able to afford to do withou"| __truncated__ "The ease, availability and low cost of renting equipment through TB." ...
$ eco_purchase : num [1:45] 2000 200 400 5000 1000 1000 3500 2000 5000 1000 ...
$ eco_storage : num [1:45] 2000 0 1500 1000 0 500 1500 250 500 0 ...
$ eco_maintain : num [1:45] 1000 0 50 500 0 1000 250 500 200 500 ...
$ eco_totalcost : num [1:45] 3000 200 2800 2000 1000 5000 2000 3000 1000 0 ...
$ eco_events : num [1:45] 6 4 3 5 2 30 30 2 20 4 ...
$ eco_nothost : num [1:45] 5 0 1 0 0 10 5 0 10 4 ...
$ eco_constit : num [1:45] 1000 5 175 300 300 200 100 100 500 100 ...
$ ci_exaccomp : chr [1:45] "Hosted additional projects or events" "Hosted additional projects or events" "N/A" "More money towards other event aspects" ...
$ ci_cutfund : chr [1:45] "Staff" "N/A" "Projects" "Projects" ...
$ ci_otr : num [1:45] NA NA NA NA NA NA 5000 NA NA NA ...
$ ci_staff : num [1:45] 3 NA NA NA NA 0 NA NA NA NA ...
$ ci_project : num [1:45] NA NA 3 2 NA 8 NA 15 10 4 ...
$ ci_evimpact : chr [1:45] "Quantity, Quality, Consistency" "Quantity, Quality" "Quantity, Consistency" "Quality, Consistency" ...
$ eve_type : chr [1:45] "Service Projects, Educational Workshops, Community Building" "Fundraising, Community Building" "Fundraising, volunteer appreciation" "Fundraising, Service Projects, Community Building, Thank you Events" ...
$ eve_fundraise : chr [1:45] NA NA NA NA ...
$ eve_fundraise_p : num [1:45] 75 10 10 3 2 30 25 0 50 0 ...change multiple choice answer into numbers
The following section is commented out as we used text format choices in the following study
split check all that apply responses into indicators
[1] 4
[1] 5
[1] 7
[1] 8
[1] 13
[1] 15
[1] 18
[1] 22
[1] 27
[1] 30
[1] 37[1] 7
[1] 12
[1] 13
[1] 15
[1] 21
[1] 22
[1] 27[1] 15
[1] 29[1] 3
[1] 4
[1] 7
[1] 13
[1] 27
[1] 42Merge Gross Recipts to datasheet and add stratification
Start of Farrie Analysis
Question: How long have you worked with this organization?
Boxplot and Historgram of Years Worked
Measure Value
1 Mean 2.177778
2 Median 2.000000
3 Mode 3.000000Question: How long have you worked with this organization? (Plan 2)
1 2 3
11 15 19 [1] 4.111111[1] 1.991142[1] 4
Section 2: Demographic Information
Response Analysis
Question:The following question pertains to minority leadership and service. For the purpose of this question, minority is defined as women, people of color, and immigrants. Ehich of the following best describes your organization? (please provide your best estimate).?
Percent of respondents stating, “our top executive position is held by a minority”
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 0 20 0 0.4444444
2 1 25 1 0.5555556Percent of respondents stating, “More than 50% of our board is made up of minorities”
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 0 26 0 0.5777778
2 1 19 1 0.4222222Percent of respondents stating, “More than 50% of program recipients are minorities”
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 0 19 0 0.4222222
2 1 26 1 0.5777778Percent of respondents stating, “None of the above”
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 0 40 0 0.8888889
2 1 5 1 0.1111111Based on the metrics above, 86% of the survey respondents reported to at least of the minority service or leadership criteria.
Plots
general sentiment and years with the CBO
general sentiment and size of CBO
| Number, percentages of CBOs in size categories | ||
| Number Respondants | Percent of Total Respondants | |
|---|---|---|
| CBO Size | ||
| Less than 500k (group 1) | 21 | 46.7% |
| Between 500k and 1000k (group 2) | 2 | 4.4% |
| Greater than 1000k (group 3) | 12 | 26.7% |
| NA | 10 | 22.2% |
general sentiment and minority status
| Number, percentages of respondants indicating minority leadership | ||
| # Yes (% Yes) | # No (% No) | |
|---|---|---|
| Minority Leadership | ||
| Our top executive position is held by a minority | 25 (56%) | 20 (44%) |
| More than 50% of our board is made up of minorities | 19 (42%) | 26 (58%) |
| More than 50% of program recipients are minorities | 26 (58%) | 19 (42%) |
| None of the above | 5 (11%) | 40 (89%) |
Section 3: General Attitudes
Response analysis
overall table:
| Number, percentages of respondants to sentiment questions | ||||||
| #Strongly Agree (%) | #Agree (%) | #Neutral (%) | #Disagree (%) | #Strongly Disagree (%) | #N/A (%) | |
|---|---|---|---|---|---|---|
| TB has pos. impacted our CBO by reducing costs related to purchasing or renting tools and equipment | 42 (93.3%) | 3 (6.7%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) |
| TB has pos. impacted our CBO by reducing costs related to storing tools and equipment | 26 (57.8%) | 7 (15.6%) | 7 (15.6%) | 0 (0%) | 0 (0%) | 5 (11.1%) |
| TB has pos. impacted our CBO by reducing staff time to complete maintenance/projects | 19 (42.2%) | 11 (24.4%) | 8 (17.8%) | 2 (4.4%) | 0 (0%) | 5 (11.1%) |
| the Tools made available through the TB allow our CBO to complete higher quality events/projects without additional funding | 36 (80%) | 7 (15.6%) | 2 (4.4%) | 0 (0%) | 0 (0%) | 0 (0%) |
| TB has pos. impacted our CBO | 42 (93.3%) | 3 (6.7%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) |
Percent of respondents that reported “Agreeing” or “Strongly Agreeing” that, “the ToolBank (TB) has positively impacted our CBO by reducing costs related to purchasing or renting tools and equipment”
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 Agree 3 Agree 0.06666667
2 Strongly agree 42 Strongly agree 0.93333333Percent of respondents that reported “Agreeing” or “strongly Agreeing” that, "the TB has positively impacted our CBO by reducing costs related to storing tools and equipment
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 Agree 7 Agree 0.1555556
2 N/A 5 N/A 0.1111111
3 Neutral 7 Neutral 0.1555556
4 Strongly agree 26 Strongly agree 0.5777778Percent of respondents that reported “Agreeing” or “strongly Agreeing” that, "theTB has positively impacted our CBO by reducing staff time to complete maintenance/projects
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 Agree 11 Agree 0.24444444
2 Disagree 2 Disagree 0.04444444
3 N/A 5 N/A 0.11111111
4 Neutral 8 Neutral 0.17777778
5 Strongly agree 19 Strongly agree 0.42222222Percent of respondents that reported “Agreeing” or “strongly Agreeing” that, "the Tools made available through the TB allow our CBO to complete higher quality events/projects without additional funding
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 Agree 7 Agree 0.15555556
2 Neutral 2 Neutral 0.04444444
3 Strongly agree 36 Strongly agree 0.80000000Question: TB has positively impacted our CBO
count.Var1 count.Freq Percentage.Var1 Percentage.Freq
1 Agree 3 Agree 0.06666667
2 Strongly agree 42 Strongly agree 0.93333333Plots
Section 4: Economic Benefit
Response analysis
Question: How much would you have spent purchasing or renting tools and equipment had the TB not existed?
Measure Value
1 Mean 5028.889
2 Median 2000.000
3 Mode 2000.000
4 sd 14108.953
5 1st quantile 500.000
6 3rd quantile 3500.000
Question: How much would you have spent on storage of tools and equipment had the TB not existed ?
Measure Value
1 Mean 925.5556
2 Median 500.0000
3 Mode 0.0000
4 sd 1195.7606
5 1st quantile 0.0000
6 3rd quantile 1200.0000
Question: How much would you have spent on maintenance of tools and equipment had the TB not existed?
Measure Value
1 Mean 816.6667
2 Median 300.0000
3 Mode 500.0000
4 sd 2227.4466
5 1st quantile 80.0000
6 3rd quantile 500.0000
Question: Reflecting on your events in the past year: If the TB did not exist, how much funding would your organization allocate to buying, storing, tracking and maintaining your own inventory of tools and equipment?
Measure Value
1 Mean 2527.111
2 Median 1500.000
3 Mode 5000.000
4 sd 2532.100
5 1st quantile 800.000
6 3rd quantile 3000.000
Question: number of total events hosted during last year
Measure Value
1 Mean 17.55556
2 Median 6.00000
3 Mode 3.00000
4 sd 25.65466
5 1st quantile 4.00000
6 3rd quantile 20.00000
Question: If there were no TB, how many of your events in the past year would you not have been hosted for any reason?
Measure Value
1 Mean 6.222222
2 Median 2.000000
3 Mode 0.000000
4 sd 15.597041
5 1st quantile 1.000000
6 3rd quantile 5.000000
Extra analysis: percent of event not host during last year
Measure Value
1 Mean 0.4057342
2 Median 0.3500000
3 Mode 0.0000000
Questions: If there were no TB, how many of your constituents, including volunteers, members, and event attendees, would have been negatively impacted in the past year?
Measure Value
1 Mean 1306.444
2 Median 150.000
3 Mode 100.000
4 sd 3077.895
5 1st quantile 75.000
6 3rd quantile 500.000
Calculated:
Reflecting on your events in the past year, how many events did your organization host?
If there were no TB, how many of your events in the past year would you not have been able to host?
What percentage of the events hosted last year did the TB help make possible?
put all this into one table:| Impact on CBO if TB did not exists | ||||||
| Mean | 25th quantile | Median | Mode | 75th quantile | Standard deviation | |
|---|---|---|---|---|---|---|
| Money That Would Have Been Spent if TB Did Not Exist* | ||||||
| on Purchasing or renting tools and equipment | 5029 | 500 | 2000 | 2000 | 3500 | 14109 |
| on storage of tools and equipment | 926 | 0 | 500 | 0 | 1200 | 1196 |
| on maintenance of tools and equipment | 817 | 80 | 300 | 500 | 500 | 2227 |
| on buying, storing, tracking and maintaining own tool+equiptment inventory | 2527 | 800 | 1500 | 5000 | 3000 | 2532 |
| # Events/People Impacted If TB Did Not Exist | ||||||
| # events that would have been impossible in past year | 6 | 1 | 2 | 0 | 5 | 16 |
| % of CBO’s total events that would have been impossible in past year | 41 | 4 | 35 | 0 | 62 | 36 |
| # constituents that would have been negatively impacted in the past year | 1306 | 75 | 150 | 100 | 500 | 3078 |
| *in US dollars | ||||||
Plots
Section 5: Community Impact
Question: With the money that you have saved on purchasing, storing, and maintaining tools and equipment, what have you been able to accomplish?Among partners indicated certain effect, what is the average quantified effects
[1] 1.5[1] 2.12132[1] 5.04[1] 4.568734Quantify effect of “other”, if selected
Analysis surroundingg questions
Question: do organizations with higher savings through toolbank report more of a positive impact?
Question: How do savings vary by different toolbank offerings? 
Question: What is the relationship like between minority-led CBOs and the toolbank compared to non-minority led CBOs?
Question: where within the organization does the Toolbank impact most?
Histogram, faceted by responded staff versus responded projects– can incorporate “Other” if consistent across organizations X = number (of staff or projects) Facet: Without the TB, what would you no longer be able to fund? (code note: will also have to manipulate data a bit to get this)
Question: In what ways has the community benefited through the toolbank? What are the most prominent types of events (or organization types) the toolbank supports?
2 bar chart X1 = ways of impact; X2 = event types Y = % respondent Can incorporate other if there is consistency across respondents
### marginal analysis on fundraising questions
[1] 45[1] 32.82222[1] 30[1] 28.83124 0% 25% 50% 75% 100%
0 10 30 50 100